using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VPTSORT
    {
        public DataRow Convert2PTSORT(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryPTSORT(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["PTSMANDANT"] = " ".PadRight(2 ); 
         dwReturn["PTSPKSTKRS"] = " ".PadRight(2 ); 
         dwReturn["PTSPKST"] = " ".PadRight(4 ); 
         dwReturn["PTSMTYP"] = " ".PadRight(8 ); 
         dwReturn["PTSAGANG"] = " ".PadRight(15 ); 
         dwReturn["PTSNEUB"] = " ".PadRight(8 ); 
         dwReturn["PTSNEUD"] = " ".PadRight(0 ); 
         dwReturn["PTSAENB"] = " ".PadRight(8 ); 
         dwReturn["PTSAEND"] = " ".PadRight(0 ); 
         dwReturn["PTSAENZL"] = " ".PadRight(0 ); 
         dwReturn["PTSANZEIGEE"] = " ".PadRight(1 ); 
         dwReturn["PTSMELDKZ"] = " ".PadRight(1 ); 
         dwReturn["PTSAZUGET"] = " ".PadRight(1 ); 
         dwReturn["PTSAGANGG"] = " ".PadRight(15 ); 
         dwReturn["PTSAGANGINF"] = " ".PadRight(1 ); 
         dwReturn["PTSAUFBER"] = " ".PadRight(2 ); 
         dwReturn["PTSSETUPTAB"] = " ".PadRight(4 ); 
         dwReturn["PTSSORTFD1"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE1"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS1"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST1"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR1"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR1"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB1"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG1"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD1"] = " ".PadRight(1 ); 
         dwReturn["PTSAB1"] = " ".PadRight(0 ); 
         dwReturn["PTSAN1"] = " ".PadRight(0 ); 
         dwReturn["PTSLG1"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB1"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB1"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD1"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG1"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT1"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK1"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD2"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE2"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS2"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST2"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR2"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR2"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB2"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG2"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD2"] = " ".PadRight(1 ); 
         dwReturn["PTSAB2"] = " ".PadRight(0 ); 
         dwReturn["PTSAN2"] = " ".PadRight(0 ); 
         dwReturn["PTSLG2"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB2"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB2"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD2"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG2"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT2"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK2"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD3"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE3"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS3"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST3"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR3"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR3"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB3"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG3"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD3"] = " ".PadRight(1 ); 
         dwReturn["PTSAB3"] = " ".PadRight(0 ); 
         dwReturn["PTSAN3"] = " ".PadRight(0 ); 
         dwReturn["PTSLG3"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB3"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB3"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD3"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG3"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT3"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK3"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD4"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE4"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS4"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST4"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR4"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR4"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB4"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG4"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD4"] = " ".PadRight(1 ); 
         dwReturn["PTSAB4"] = " ".PadRight(0 ); 
         dwReturn["PTSAN4"] = " ".PadRight(0 ); 
         dwReturn["PTSLG4"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB4"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB4"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD4"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG4"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT4"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK4"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD5"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE5"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS5"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST5"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR5"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR5"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB5"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG5"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD5"] = " ".PadRight(1 ); 
         dwReturn["PTSAB5"] = " ".PadRight(0 ); 
         dwReturn["PTSAN5"] = " ".PadRight(0 ); 
         dwReturn["PTSLG5"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB5"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB5"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD5"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG5"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT5"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK5"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD6"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE6"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS6"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST6"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR6"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR6"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB6"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG6"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD6"] = " ".PadRight(1 ); 
         dwReturn["PTSAB6"] = " ".PadRight(0 ); 
         dwReturn["PTSAN6"] = " ".PadRight(0 ); 
         dwReturn["PTSLG6"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB6"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB6"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD6"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG6"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT6"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK6"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD7"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE7"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS7"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST7"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR7"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR7"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB7"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG7"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD7"] = " ".PadRight(1 ); 
         dwReturn["PTSAB7"] = " ".PadRight(0 ); 
         dwReturn["PTSAN7"] = " ".PadRight(0 ); 
         dwReturn["PTSLG7"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB7"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB7"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD7"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG7"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT7"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK7"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD8"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE8"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS8"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST8"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR8"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR8"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB8"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG8"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD8"] = " ".PadRight(1 ); 
         dwReturn["PTSAB8"] = " ".PadRight(0 ); 
         dwReturn["PTSAN8"] = " ".PadRight(0 ); 
         dwReturn["PTSLG8"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB8"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB8"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD8"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG8"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT8"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK8"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD9"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE9"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS9"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST9"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR9"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR9"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB9"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG9"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD9"] = " ".PadRight(1 ); 
         dwReturn["PTSAB9"] = " ".PadRight(0 ); 
         dwReturn["PTSAN9"] = " ".PadRight(0 ); 
         dwReturn["PTSLG9"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB9"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB9"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD9"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG9"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT9"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK9"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD10"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE10"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS10"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST10"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR10"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR10"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB10"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG10"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD10"] = " ".PadRight(1 ); 
         dwReturn["PTSAB10"] = " ".PadRight(0 ); 
         dwReturn["PTSAN10"] = " ".PadRight(0 ); 
         dwReturn["PTSLG10"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB10"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB10"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD10"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG10"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT10"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK10"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD11"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE11"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS11"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST11"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR11"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR11"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB11"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG11"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD11"] = " ".PadRight(1 ); 
         dwReturn["PTSAB11"] = " ".PadRight(0 ); 
         dwReturn["PTSAN11"] = " ".PadRight(0 ); 
         dwReturn["PTSLG11"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB11"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB11"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD11"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG11"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT11"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK11"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD12"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE12"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS12"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST12"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR12"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR12"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB12"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG12"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD12"] = " ".PadRight(1 ); 
         dwReturn["PTSAB12"] = " ".PadRight(0 ); 
         dwReturn["PTSAN12"] = " ".PadRight(0 ); 
         dwReturn["PTSLG12"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB12"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB12"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD12"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG12"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT12"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK12"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD13"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE13"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS13"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST13"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR13"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR13"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB13"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG13"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD13"] = " ".PadRight(1 ); 
         dwReturn["PTSAB13"] = " ".PadRight(0 ); 
         dwReturn["PTSAN13"] = " ".PadRight(0 ); 
         dwReturn["PTSLG13"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB13"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB13"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD13"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG13"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT13"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK13"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD14"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE14"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS14"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST14"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR14"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR14"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB14"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG14"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD14"] = " ".PadRight(1 ); 
         dwReturn["PTSAB14"] = " ".PadRight(0 ); 
         dwReturn["PTSAN14"] = " ".PadRight(0 ); 
         dwReturn["PTSLG14"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB14"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB14"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD14"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG14"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT14"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK14"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD15"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE15"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS15"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST15"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR15"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR15"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB15"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG15"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD15"] = " ".PadRight(1 ); 
         dwReturn["PTSAB15"] = " ".PadRight(0 ); 
         dwReturn["PTSAN15"] = " ".PadRight(0 ); 
         dwReturn["PTSLG15"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB15"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB15"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD15"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG15"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT15"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK15"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD16"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE16"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS16"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST16"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR16"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR16"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB16"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG16"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD16"] = " ".PadRight(1 ); 
         dwReturn["PTSAB16"] = " ".PadRight(0 ); 
         dwReturn["PTSAN16"] = " ".PadRight(0 ); 
         dwReturn["PTSLG16"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB16"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB16"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD16"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG16"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT16"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK16"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD17"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE17"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS17"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST17"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR17"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR17"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB17"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG17"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD17"] = " ".PadRight(1 ); 
         dwReturn["PTSAB17"] = " ".PadRight(0 ); 
         dwReturn["PTSAN17"] = " ".PadRight(0 ); 
         dwReturn["PTSLG17"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB17"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB17"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD17"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG17"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT17"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK17"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD18"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE18"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS18"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST18"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR18"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR18"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB18"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG18"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD18"] = " ".PadRight(1 ); 
         dwReturn["PTSAB18"] = " ".PadRight(0 ); 
         dwReturn["PTSAN18"] = " ".PadRight(0 ); 
         dwReturn["PTSLG18"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB18"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB18"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD18"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG18"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT18"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK18"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD19"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE19"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS19"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST19"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR19"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR19"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB19"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG19"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD19"] = " ".PadRight(1 ); 
         dwReturn["PTSAB19"] = " ".PadRight(0 ); 
         dwReturn["PTSAN19"] = " ".PadRight(0 ); 
         dwReturn["PTSLG19"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB19"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB19"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD19"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG19"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT19"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK19"] = " ".PadRight(1 ); 
         dwReturn["PTSSORTFD20"] = " ".PadRight(2 ); 
         dwReturn["PTSPAFOLGE20"] = " ".PadRight(0 ); 
         dwReturn["PTSPPKSTKRS20"] = " ".PadRight(2 ); 
         dwReturn["PTSPPKST20"] = " ".PadRight(4 ); 
         dwReturn["PTSMODNR20"] = " ".PadRight(3 ); 
         dwReturn["PTSEINSTNR20"] = " ".PadRight(3 ); 
         dwReturn["PTSKAB20"] = " ".PadRight(0 ); 
         dwReturn["PTSKLG20"] = " ".PadRight(0 ); 
         dwReturn["PTSFELD20"] = " ".PadRight(1 ); 
         dwReturn["PTSAB20"] = " ".PadRight(0 ); 
         dwReturn["PTSAN20"] = " ".PadRight(0 ); 
         dwReturn["PTSLG20"] = " ".PadRight(0 ); 
         dwReturn["PTSFARBTAB20"] = " ".PadRight(0 ); 
         dwReturn["PTSRUESTTAB20"] = " ".PadRight(2 ); 
         dwReturn["PTSPBILD20"] = " ".PadRight(1 ); 
         dwReturn["PTSPAGANG20"] = " ".PadRight(15 ); 
         dwReturn["PTSPSORT20"] = " ".PadRight(1 ); 
         dwReturn["PTSCONMARK20"] = " ".PadRight(1 ); 
         dwReturn["PTSAPTNRKRS"] = " ".PadRight(2 ); 
         dwReturn["PTSAME1"] = " ".PadRight(1 ); 
         dwReturn["PTSAME2"] = " ".PadRight(1 ); 
         dwReturn["PTSAGRP"] = " ".PadRight(1 ); 
         dwReturn["PTSBPTNRKRS"] = " ".PadRight(2 ); 
         dwReturn["PTSART"] = " ".PadRight(1 ); 
         dwReturn["PTSBME1"] = " ".PadRight(1 ); 
         dwReturn["PTSBME2"] = " ".PadRight(1 ); 
         dwReturn["PTSBGRP"] = " ".PadRight(1 ); 
         dwReturn["PTSKUNDE"] = " ".PadRight(1 ); 
         dwReturn["PTSPFLKZ"] = " ".PadRight(1 ); 
         dwReturn["PTSTERM"] = " ".PadRight(1 ); 
         dwReturn["PTSMTYPKZ"] = " ".PadRight(1 ); 
         dwReturn["PTSWEEKPL"] = " ".PadRight(1 ); 
         dwReturn["PTSWEEK"] = " ".PadRight(1 ); 
         dwReturn["PTSWEEKST"] = " ".PadRight(1 ); 
         dwReturn["PTSSETUPTM"] = " ".PadRight(1 ); 
         dwReturn["PTSSETUPTM1"] = " ".PadRight(0 ); 
         dwReturn["PTSSETUPTM2"] = " ".PadRight(0 ); 
         dwReturn["PTSSCROLL"] = " ".PadRight(2 ); 
         dwReturn["PTSCONDAT"] = " ".PadRight(1 ); 
         dwReturn["PTSFILLER"] = " ".PadRight(212 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapPTSORT(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SavePTSORT(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryPTSORT(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapPTSORT(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertPTSORT(dwLocal, ITXDBVERSION);
            }
            UpdatePTSORT(dwLocal);
        }
        public void InsertPTSORT(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO PTSORT(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryPTSORT(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM PTSORT WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM PTSORT  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "PTSORT";
            Return = Result;
            return Return;
        }
        public void DeletePTSORT(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM PTSORT   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdatePTSORT(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE PTSORT SET "
                    +"PTSMANDANT= :PTSMANDANT,"
                    +"PTSPKSTKRS= :PTSPKSTKRS,"
                    +"PTSPKST= :PTSPKST,"
                    +"PTSMTYP= :PTSMTYP,"
                    +"PTSAGANG= :PTSAGANG,"
                    +"PTSNEUB= :PTSNEUB,"
                    +"PTSNEUD= :PTSNEUD,"
                    +"PTSAENB= :PTSAENB,"
                    +"PTSAEND= :PTSAEND,"
                    +"PTSAENZL= :PTSAENZL,"
                    +"PTSANZEIGEE= :PTSANZEIGEE,"
                    +"PTSMELDKZ= :PTSMELDKZ,"
                    +"PTSAZUGET= :PTSAZUGET,"
                    +"PTSAGANGG= :PTSAGANGG,"
                    +"PTSAGANGINF= :PTSAGANGINF,"
                    +"PTSAUFBER= :PTSAUFBER,"
                    +"PTSSETUPTAB= :PTSSETUPTAB,"
                    +"PTSSORTFD1= :PTSSORTFD1,"
                    +"PTSPAFOLGE1= :PTSPAFOLGE1,"
                    +"PTSPPKSTKRS1= :PTSPPKSTKRS1,"
                    +"PTSPPKST1= :PTSPPKST1,"
                    +"PTSMODNR1= :PTSMODNR1,"
                    +"PTSEINSTNR1= :PTSEINSTNR1,"
                    +"PTSKAB1= :PTSKAB1,"
                    +"PTSKLG1= :PTSKLG1,"
                    +"PTSFELD1= :PTSFELD1,"
                    +"PTSAB1= :PTSAB1,"
                    +"PTSAN1= :PTSAN1,"
                    +"PTSLG1= :PTSLG1,"
                    +"PTSFARBTAB1= :PTSFARBTAB1,"
                    +"PTSRUESTTAB1= :PTSRUESTTAB1,"
                    +"PTSPBILD1= :PTSPBILD1,"
                    +"PTSPAGANG1= :PTSPAGANG1,"
                    +"PTSPSORT1= :PTSPSORT1,"
                    +"PTSCONMARK1= :PTSCONMARK1,"
                    +"PTSSORTFD2= :PTSSORTFD2,"
                    +"PTSPAFOLGE2= :PTSPAFOLGE2,"
                    +"PTSPPKSTKRS2= :PTSPPKSTKRS2,"
                    +"PTSPPKST2= :PTSPPKST2,"
                    +"PTSMODNR2= :PTSMODNR2,"
                    +"PTSEINSTNR2= :PTSEINSTNR2,"
                    +"PTSKAB2= :PTSKAB2,"
                    +"PTSKLG2= :PTSKLG2,"
                    +"PTSFELD2= :PTSFELD2,"
                    +"PTSAB2= :PTSAB2,"
                    +"PTSAN2= :PTSAN2,"
                    +"PTSLG2= :PTSLG2,"
                    +"PTSFARBTAB2= :PTSFARBTAB2,"
                    +"PTSRUESTTAB2= :PTSRUESTTAB2,"
                    +"PTSPBILD2= :PTSPBILD2,"
                    +"PTSPAGANG2= :PTSPAGANG2,"
                    +"PTSPSORT2= :PTSPSORT2,"
                    +"PTSCONMARK2= :PTSCONMARK2,"
                    +"PTSSORTFD3= :PTSSORTFD3,"
                    +"PTSPAFOLGE3= :PTSPAFOLGE3,"
                    +"PTSPPKSTKRS3= :PTSPPKSTKRS3,"
                    +"PTSPPKST3= :PTSPPKST3,"
                    +"PTSMODNR3= :PTSMODNR3,"
                    +"PTSEINSTNR3= :PTSEINSTNR3,"
                    +"PTSKAB3= :PTSKAB3,"
                    +"PTSKLG3= :PTSKLG3,"
                    +"PTSFELD3= :PTSFELD3,"
                    +"PTSAB3= :PTSAB3,"
                    +"PTSAN3= :PTSAN3,"
                    +"PTSLG3= :PTSLG3,"
                    +"PTSFARBTAB3= :PTSFARBTAB3,"
                    +"PTSRUESTTAB3= :PTSRUESTTAB3,"
                    +"PTSPBILD3= :PTSPBILD3,"
                    +"PTSPAGANG3= :PTSPAGANG3,"
                    +"PTSPSORT3= :PTSPSORT3,"
                    +"PTSCONMARK3= :PTSCONMARK3,"
                    +"PTSSORTFD4= :PTSSORTFD4,"
                    +"PTSPAFOLGE4= :PTSPAFOLGE4,"
                    +"PTSPPKSTKRS4= :PTSPPKSTKRS4,"
                    +"PTSPPKST4= :PTSPPKST4,"
                    +"PTSMODNR4= :PTSMODNR4,"
                    +"PTSEINSTNR4= :PTSEINSTNR4,"
                    +"PTSKAB4= :PTSKAB4,"
                    +"PTSKLG4= :PTSKLG4,"
                    +"PTSFELD4= :PTSFELD4,"
                    +"PTSAB4= :PTSAB4,"
                    +"PTSAN4= :PTSAN4,"
                    +"PTSLG4= :PTSLG4,"
                    +"PTSFARBTAB4= :PTSFARBTAB4,"
                    +"PTSRUESTTAB4= :PTSRUESTTAB4,"
                    +"PTSPBILD4= :PTSPBILD4,"
                    +"PTSPAGANG4= :PTSPAGANG4,"
                    +"PTSPSORT4= :PTSPSORT4,"
                    +"PTSCONMARK4= :PTSCONMARK4,"
                    +"PTSSORTFD5= :PTSSORTFD5,"
                    +"PTSPAFOLGE5= :PTSPAFOLGE5,"
                    +"PTSPPKSTKRS5= :PTSPPKSTKRS5,"
                    +"PTSPPKST5= :PTSPPKST5,"
                    +"PTSMODNR5= :PTSMODNR5,"
                    +"PTSEINSTNR5= :PTSEINSTNR5,"
                    +"PTSKAB5= :PTSKAB5,"
                    +"PTSKLG5= :PTSKLG5,"
                    +"PTSFELD5= :PTSFELD5,"
                    +"PTSAB5= :PTSAB5,"
                    +"PTSAN5= :PTSAN5,"
                    +"PTSLG5= :PTSLG5,"
                    +"PTSFARBTAB5= :PTSFARBTAB5,"
                    +"PTSRUESTTAB5= :PTSRUESTTAB5,"
                    +"PTSPBILD5= :PTSPBILD5,"
                    +"PTSPAGANG5= :PTSPAGANG5,"
                    +"PTSPSORT5= :PTSPSORT5,"
                    +"PTSCONMARK5= :PTSCONMARK5,"
                    +"PTSSORTFD6= :PTSSORTFD6,"
                    +"PTSPAFOLGE6= :PTSPAFOLGE6,"
                    +"PTSPPKSTKRS6= :PTSPPKSTKRS6,"
                    +"PTSPPKST6= :PTSPPKST6,"
                    +"PTSMODNR6= :PTSMODNR6,"
                    +"PTSEINSTNR6= :PTSEINSTNR6,"
                    +"PTSKAB6= :PTSKAB6,"
                    +"PTSKLG6= :PTSKLG6,"
                    +"PTSFELD6= :PTSFELD6,"
                    +"PTSAB6= :PTSAB6,"
                    +"PTSAN6= :PTSAN6,"
                    +"PTSLG6= :PTSLG6,"
                    +"PTSFARBTAB6= :PTSFARBTAB6,"
                    +"PTSRUESTTAB6= :PTSRUESTTAB6,"
                    +"PTSPBILD6= :PTSPBILD6,"
                    +"PTSPAGANG6= :PTSPAGANG6,"
                    +"PTSPSORT6= :PTSPSORT6,"
                    +"PTSCONMARK6= :PTSCONMARK6,"
                    +"PTSSORTFD7= :PTSSORTFD7,"
                    +"PTSPAFOLGE7= :PTSPAFOLGE7,"
                    +"PTSPPKSTKRS7= :PTSPPKSTKRS7,"
                    +"PTSPPKST7= :PTSPPKST7,"
                    +"PTSMODNR7= :PTSMODNR7,"
                    +"PTSEINSTNR7= :PTSEINSTNR7,"
                    +"PTSKAB7= :PTSKAB7,"
                    +"PTSKLG7= :PTSKLG7,"
                    +"PTSFELD7= :PTSFELD7,"
                    +"PTSAB7= :PTSAB7,"
                    +"PTSAN7= :PTSAN7,"
                    +"PTSLG7= :PTSLG7,"
                    +"PTSFARBTAB7= :PTSFARBTAB7,"
                    +"PTSRUESTTAB7= :PTSRUESTTAB7,"
                    +"PTSPBILD7= :PTSPBILD7,"
                    +"PTSPAGANG7= :PTSPAGANG7,"
                    +"PTSPSORT7= :PTSPSORT7,"
                    +"PTSCONMARK7= :PTSCONMARK7,"
                    +"PTSSORTFD8= :PTSSORTFD8,"
                    +"PTSPAFOLGE8= :PTSPAFOLGE8,"
                    +"PTSPPKSTKRS8= :PTSPPKSTKRS8,"
                    +"PTSPPKST8= :PTSPPKST8,"
                    +"PTSMODNR8= :PTSMODNR8,"
                    +"PTSEINSTNR8= :PTSEINSTNR8,"
                    +"PTSKAB8= :PTSKAB8,"
                    +"PTSKLG8= :PTSKLG8,"
                    +"PTSFELD8= :PTSFELD8,"
                    +"PTSAB8= :PTSAB8,"
                    +"PTSAN8= :PTSAN8,"
                    +"PTSLG8= :PTSLG8,"
                    +"PTSFARBTAB8= :PTSFARBTAB8,"
                    +"PTSRUESTTAB8= :PTSRUESTTAB8,"
                    +"PTSPBILD8= :PTSPBILD8,"
                    +"PTSPAGANG8= :PTSPAGANG8,"
                    +"PTSPSORT8= :PTSPSORT8,"
                    +"PTSCONMARK8= :PTSCONMARK8,"
                    +"PTSSORTFD9= :PTSSORTFD9,"
                    +"PTSPAFOLGE9= :PTSPAFOLGE9,"
                    +"PTSPPKSTKRS9= :PTSPPKSTKRS9,"
                    +"PTSPPKST9= :PTSPPKST9,"
                    +"PTSMODNR9= :PTSMODNR9,"
                    +"PTSEINSTNR9= :PTSEINSTNR9,"
                    +"PTSKAB9= :PTSKAB9,"
                    +"PTSKLG9= :PTSKLG9,"
                    +"PTSFELD9= :PTSFELD9,"
                    +"PTSAB9= :PTSAB9,"
                    +"PTSAN9= :PTSAN9,"
                    +"PTSLG9= :PTSLG9,"
                    +"PTSFARBTAB9= :PTSFARBTAB9,"
                    +"PTSRUESTTAB9= :PTSRUESTTAB9,"
                    +"PTSPBILD9= :PTSPBILD9,"
                    +"PTSPAGANG9= :PTSPAGANG9,"
                    +"PTSPSORT9= :PTSPSORT9,"
                    +"PTSCONMARK9= :PTSCONMARK9,"
                    +"PTSSORTFD10= :PTSSORTFD10,"
                    +"PTSPAFOLGE10= :PTSPAFOLGE10,"
                    +"PTSPPKSTKRS10= :PTSPPKSTKRS10,"
                    +"PTSPPKST10= :PTSPPKST10,"
                    +"PTSMODNR10= :PTSMODNR10,"
                    +"PTSEINSTNR10= :PTSEINSTNR10,"
                    +"PTSKAB10= :PTSKAB10,"
                    +"PTSKLG10= :PTSKLG10,"
                    +"PTSFELD10= :PTSFELD10,"
                    +"PTSAB10= :PTSAB10,"
                    +"PTSAN10= :PTSAN10,"
                    +"PTSLG10= :PTSLG10,"
                    +"PTSFARBTAB10= :PTSFARBTAB10,"
                    +"PTSRUESTTAB10= :PTSRUESTTAB10,"
                    +"PTSPBILD10= :PTSPBILD10,"
                    +"PTSPAGANG10= :PTSPAGANG10,"
                    +"PTSPSORT10= :PTSPSORT10,"
                    +"PTSCONMARK10= :PTSCONMARK10,"
                    +"PTSSORTFD11= :PTSSORTFD11,"
                    +"PTSPAFOLGE11= :PTSPAFOLGE11,"
                    +"PTSPPKSTKRS11= :PTSPPKSTKRS11,"
                    +"PTSPPKST11= :PTSPPKST11,"
                    +"PTSMODNR11= :PTSMODNR11,"
                    +"PTSEINSTNR11= :PTSEINSTNR11,"
                    +"PTSKAB11= :PTSKAB11,"
                    +"PTSKLG11= :PTSKLG11,"
                    +"PTSFELD11= :PTSFELD11,"
                    +"PTSAB11= :PTSAB11,"
                    +"PTSAN11= :PTSAN11,"
                    +"PTSLG11= :PTSLG11,"
                    +"PTSFARBTAB11= :PTSFARBTAB11,"
                    +"PTSRUESTTAB11= :PTSRUESTTAB11,"
                    +"PTSPBILD11= :PTSPBILD11,"
                    +"PTSPAGANG11= :PTSPAGANG11,"
                    +"PTSPSORT11= :PTSPSORT11,"
                    +"PTSCONMARK11= :PTSCONMARK11,"
                    +"PTSSORTFD12= :PTSSORTFD12,"
                    +"PTSPAFOLGE12= :PTSPAFOLGE12,"
                    +"PTSPPKSTKRS12= :PTSPPKSTKRS12,"
                    +"PTSPPKST12= :PTSPPKST12,"
                    +"PTSMODNR12= :PTSMODNR12,"
                    +"PTSEINSTNR12= :PTSEINSTNR12,"
                    +"PTSKAB12= :PTSKAB12,"
                    +"PTSKLG12= :PTSKLG12,"
                    +"PTSFELD12= :PTSFELD12,"
                    +"PTSAB12= :PTSAB12,"
                    +"PTSAN12= :PTSAN12,"
                    +"PTSLG12= :PTSLG12,"
                    +"PTSFARBTAB12= :PTSFARBTAB12,"
                    +"PTSRUESTTAB12= :PTSRUESTTAB12,"
                    +"PTSPBILD12= :PTSPBILD12,"
                    +"PTSPAGANG12= :PTSPAGANG12,"
                    +"PTSPSORT12= :PTSPSORT12,"
                    +"PTSCONMARK12= :PTSCONMARK12,"
                    +"PTSSORTFD13= :PTSSORTFD13,"
                    +"PTSPAFOLGE13= :PTSPAFOLGE13,"
                    +"PTSPPKSTKRS13= :PTSPPKSTKRS13,"
                    +"PTSPPKST13= :PTSPPKST13,"
                    +"PTSMODNR13= :PTSMODNR13,"
                    +"PTSEINSTNR13= :PTSEINSTNR13,"
                    +"PTSKAB13= :PTSKAB13,"
                    +"PTSKLG13= :PTSKLG13,"
                    +"PTSFELD13= :PTSFELD13,"
                    +"PTSAB13= :PTSAB13,"
                    +"PTSAN13= :PTSAN13,"
                    +"PTSLG13= :PTSLG13,"
                    +"PTSFARBTAB13= :PTSFARBTAB13,"
                    +"PTSRUESTTAB13= :PTSRUESTTAB13,"
                    +"PTSPBILD13= :PTSPBILD13,"
                    +"PTSPAGANG13= :PTSPAGANG13,"
                    +"PTSPSORT13= :PTSPSORT13,"
                    +"PTSCONMARK13= :PTSCONMARK13,"
                    +"PTSSORTFD14= :PTSSORTFD14,"
                    +"PTSPAFOLGE14= :PTSPAFOLGE14,"
                    +"PTSPPKSTKRS14= :PTSPPKSTKRS14,"
                    +"PTSPPKST14= :PTSPPKST14,"
                    +"PTSMODNR14= :PTSMODNR14,"
                    +"PTSEINSTNR14= :PTSEINSTNR14,"
                    +"PTSKAB14= :PTSKAB14,"
                    +"PTSKLG14= :PTSKLG14,"
                    +"PTSFELD14= :PTSFELD14,"
                    +"PTSAB14= :PTSAB14,"
                    +"PTSAN14= :PTSAN14,"
                    +"PTSLG14= :PTSLG14,"
                    +"PTSFARBTAB14= :PTSFARBTAB14,"
                    +"PTSRUESTTAB14= :PTSRUESTTAB14,"
                    +"PTSPBILD14= :PTSPBILD14,"
                    +"PTSPAGANG14= :PTSPAGANG14,"
                    +"PTSPSORT14= :PTSPSORT14,"
                    +"PTSCONMARK14= :PTSCONMARK14,"
                    +"PTSSORTFD15= :PTSSORTFD15,"
                    +"PTSPAFOLGE15= :PTSPAFOLGE15,"
                    +"PTSPPKSTKRS15= :PTSPPKSTKRS15,"
                    +"PTSPPKST15= :PTSPPKST15,"
                    +"PTSMODNR15= :PTSMODNR15,"
                    +"PTSEINSTNR15= :PTSEINSTNR15,"
                    +"PTSKAB15= :PTSKAB15,"
                    +"PTSKLG15= :PTSKLG15,"
                    +"PTSFELD15= :PTSFELD15,"
                    +"PTSAB15= :PTSAB15,"
                    +"PTSAN15= :PTSAN15,"
                    +"PTSLG15= :PTSLG15,"
                    +"PTSFARBTAB15= :PTSFARBTAB15,"
                    +"PTSRUESTTAB15= :PTSRUESTTAB15,"
                    +"PTSPBILD15= :PTSPBILD15,"
                    +"PTSPAGANG15= :PTSPAGANG15,"
                    +"PTSPSORT15= :PTSPSORT15,"
                    +"PTSCONMARK15= :PTSCONMARK15,"
                    +"PTSSORTFD16= :PTSSORTFD16,"
                    +"PTSPAFOLGE16= :PTSPAFOLGE16,"
                    +"PTSPPKSTKRS16= :PTSPPKSTKRS16,"
                    +"PTSPPKST16= :PTSPPKST16,"
                    +"PTSMODNR16= :PTSMODNR16,"
                    +"PTSEINSTNR16= :PTSEINSTNR16,"
                    +"PTSKAB16= :PTSKAB16,"
                    +"PTSKLG16= :PTSKLG16,"
                    +"PTSFELD16= :PTSFELD16,"
                    +"PTSAB16= :PTSAB16,"
                    +"PTSAN16= :PTSAN16,"
                    +"PTSLG16= :PTSLG16,"
                    +"PTSFARBTAB16= :PTSFARBTAB16,"
                    +"PTSRUESTTAB16= :PTSRUESTTAB16,"
                    +"PTSPBILD16= :PTSPBILD16,"
                    +"PTSPAGANG16= :PTSPAGANG16,"
                    +"PTSPSORT16= :PTSPSORT16,"
                    +"PTSCONMARK16= :PTSCONMARK16,"
                    +"PTSSORTFD17= :PTSSORTFD17,"
                    +"PTSPAFOLGE17= :PTSPAFOLGE17,"
                    +"PTSPPKSTKRS17= :PTSPPKSTKRS17,"
                    +"PTSPPKST17= :PTSPPKST17,"
                    +"PTSMODNR17= :PTSMODNR17,"
                    +"PTSEINSTNR17= :PTSEINSTNR17,"
                    +"PTSKAB17= :PTSKAB17,"
                    +"PTSKLG17= :PTSKLG17,"
                    +"PTSFELD17= :PTSFELD17,"
                    +"PTSAB17= :PTSAB17,"
                    +"PTSAN17= :PTSAN17,"
                    +"PTSLG17= :PTSLG17,"
                    +"PTSFARBTAB17= :PTSFARBTAB17,"
                    +"PTSRUESTTAB17= :PTSRUESTTAB17,"
                    +"PTSPBILD17= :PTSPBILD17,"
                    +"PTSPAGANG17= :PTSPAGANG17,"
                    +"PTSPSORT17= :PTSPSORT17,"
                    +"PTSCONMARK17= :PTSCONMARK17,"
                    +"PTSSORTFD18= :PTSSORTFD18,"
                    +"PTSPAFOLGE18= :PTSPAFOLGE18,"
                    +"PTSPPKSTKRS18= :PTSPPKSTKRS18,"
                    +"PTSPPKST18= :PTSPPKST18,"
                    +"PTSMODNR18= :PTSMODNR18,"
                    +"PTSEINSTNR18= :PTSEINSTNR18,"
                    +"PTSKAB18= :PTSKAB18,"
                    +"PTSKLG18= :PTSKLG18,"
                    +"PTSFELD18= :PTSFELD18,"
                    +"PTSAB18= :PTSAB18,"
                    +"PTSAN18= :PTSAN18,"
                    +"PTSLG18= :PTSLG18,"
                    +"PTSFARBTAB18= :PTSFARBTAB18,"
                    +"PTSRUESTTAB18= :PTSRUESTTAB18,"
                    +"PTSPBILD18= :PTSPBILD18,"
                    +"PTSPAGANG18= :PTSPAGANG18,"
                    +"PTSPSORT18= :PTSPSORT18,"
                    +"PTSCONMARK18= :PTSCONMARK18,"
                    +"PTSSORTFD19= :PTSSORTFD19,"
                    +"PTSPAFOLGE19= :PTSPAFOLGE19,"
                    +"PTSPPKSTKRS19= :PTSPPKSTKRS19,"
                    +"PTSPPKST19= :PTSPPKST19,"
                    +"PTSMODNR19= :PTSMODNR19,"
                    +"PTSEINSTNR19= :PTSEINSTNR19,"
                    +"PTSKAB19= :PTSKAB19,"
                    +"PTSKLG19= :PTSKLG19,"
                    +"PTSFELD19= :PTSFELD19,"
                    +"PTSAB19= :PTSAB19,"
                    +"PTSAN19= :PTSAN19,"
                    +"PTSLG19= :PTSLG19,"
                    +"PTSFARBTAB19= :PTSFARBTAB19,"
                    +"PTSRUESTTAB19= :PTSRUESTTAB19,"
                    +"PTSPBILD19= :PTSPBILD19,"
                    +"PTSPAGANG19= :PTSPAGANG19,"
                    +"PTSPSORT19= :PTSPSORT19,"
                    +"PTSCONMARK19= :PTSCONMARK19,"
                    +"PTSSORTFD20= :PTSSORTFD20,"
                    +"PTSPAFOLGE20= :PTSPAFOLGE20,"
                    +"PTSPPKSTKRS20= :PTSPPKSTKRS20,"
                    +"PTSPPKST20= :PTSPPKST20,"
                    +"PTSMODNR20= :PTSMODNR20,"
                    +"PTSEINSTNR20= :PTSEINSTNR20,"
                    +"PTSKAB20= :PTSKAB20,"
                    +"PTSKLG20= :PTSKLG20,"
                    +"PTSFELD20= :PTSFELD20,"
                    +"PTSAB20= :PTSAB20,"
                    +"PTSAN20= :PTSAN20,"
                    +"PTSLG20= :PTSLG20,"
                    +"PTSFARBTAB20= :PTSFARBTAB20,"
                    +"PTSRUESTTAB20= :PTSRUESTTAB20,"
                    +"PTSPBILD20= :PTSPBILD20,"
                    +"PTSPAGANG20= :PTSPAGANG20,"
                    +"PTSPSORT20= :PTSPSORT20,"
                    +"PTSCONMARK20= :PTSCONMARK20,"
                    +"PTSAPTNRKRS= :PTSAPTNRKRS,"
                    +"PTSAME1= :PTSAME1,"
                    +"PTSAME2= :PTSAME2,"
                    +"PTSAGRP= :PTSAGRP,"
                    +"PTSBPTNRKRS= :PTSBPTNRKRS,"
                    +"PTSART= :PTSART,"
                    +"PTSBME1= :PTSBME1,"
                    +"PTSBME2= :PTSBME2,"
                    +"PTSBGRP= :PTSBGRP,"
                    +"PTSKUNDE= :PTSKUNDE,"
                    +"PTSPFLKZ= :PTSPFLKZ,"
                    +"PTSTERM= :PTSTERM,"
                    +"PTSMTYPKZ= :PTSMTYPKZ,"
                    +"PTSWEEKPL= :PTSWEEKPL,"
                    +"PTSWEEK= :PTSWEEK,"
                    +"PTSWEEKST= :PTSWEEKST,"
                    +"PTSSETUPTM= :PTSSETUPTM,"
                    +"PTSSETUPTM1= :PTSSETUPTM1,"
                    +"PTSSETUPTM2= :PTSSETUPTM2,"
                    +"PTSSCROLL= :PTSSCROLL,"
                    +"PTSCONDAT= :PTSCONDAT,"
                    +"PTSFILLER= :PTSFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("PTSMANDANT", OracleType.NVarChar).Value = dwData["PTSMANDANT"].ToString(); 
          or1.Parameters.Add("PTSPKSTKRS", OracleType.NVarChar).Value = dwData["PTSPKSTKRS"].ToString(); 
          or1.Parameters.Add("PTSPKST", OracleType.NVarChar).Value = dwData["PTSPKST"].ToString(); 
          or1.Parameters.Add("PTSMTYP", OracleType.NVarChar).Value = dwData["PTSMTYP"].ToString(); 
          or1.Parameters.Add("PTSAGANG", OracleType.NVarChar).Value = dwData["PTSAGANG"].ToString(); 
          or1.Parameters.Add("PTSNEUB", OracleType.NVarChar).Value = dwData["PTSNEUB"].ToString(); 
          or1.Parameters.Add("PTSNEUD", OracleType.NVarChar).Value = dwData["PTSNEUD"].ToString(); 
          or1.Parameters.Add("PTSAENB", OracleType.NVarChar).Value = dwData["PTSAENB"].ToString(); 
          or1.Parameters.Add("PTSAEND", OracleType.NVarChar).Value = dwData["PTSAEND"].ToString(); 
          or1.Parameters.Add("PTSAENZL", OracleType.NVarChar).Value = dwData["PTSAENZL"].ToString(); 
          or1.Parameters.Add("PTSANZEIGEE", OracleType.NVarChar).Value = dwData["PTSANZEIGEE"].ToString(); 
          or1.Parameters.Add("PTSMELDKZ", OracleType.NVarChar).Value = dwData["PTSMELDKZ"].ToString(); 
          or1.Parameters.Add("PTSAZUGET", OracleType.NVarChar).Value = dwData["PTSAZUGET"].ToString(); 
          or1.Parameters.Add("PTSAGANGG", OracleType.NVarChar).Value = dwData["PTSAGANGG"].ToString(); 
          or1.Parameters.Add("PTSAGANGINF", OracleType.NVarChar).Value = dwData["PTSAGANGINF"].ToString(); 
          or1.Parameters.Add("PTSAUFBER", OracleType.NVarChar).Value = dwData["PTSAUFBER"].ToString(); 
          or1.Parameters.Add("PTSSETUPTAB", OracleType.NVarChar).Value = dwData["PTSSETUPTAB"].ToString(); 
          or1.Parameters.Add("PTSSORTFD1", OracleType.NVarChar).Value = dwData["PTSSORTFD1"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE1", OracleType.NVarChar).Value = dwData["PTSPAFOLGE1"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS1", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS1"].ToString(); 
          or1.Parameters.Add("PTSPPKST1", OracleType.NVarChar).Value = dwData["PTSPPKST1"].ToString(); 
          or1.Parameters.Add("PTSMODNR1", OracleType.NVarChar).Value = dwData["PTSMODNR1"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR1", OracleType.NVarChar).Value = dwData["PTSEINSTNR1"].ToString(); 
          or1.Parameters.Add("PTSKAB1", OracleType.NVarChar).Value = dwData["PTSKAB1"].ToString(); 
          or1.Parameters.Add("PTSKLG1", OracleType.NVarChar).Value = dwData["PTSKLG1"].ToString(); 
          or1.Parameters.Add("PTSFELD1", OracleType.NVarChar).Value = dwData["PTSFELD1"].ToString(); 
          or1.Parameters.Add("PTSAB1", OracleType.NVarChar).Value = dwData["PTSAB1"].ToString(); 
          or1.Parameters.Add("PTSAN1", OracleType.NVarChar).Value = dwData["PTSAN1"].ToString(); 
          or1.Parameters.Add("PTSLG1", OracleType.NVarChar).Value = dwData["PTSLG1"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB1", OracleType.NVarChar).Value = dwData["PTSFARBTAB1"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB1", OracleType.NVarChar).Value = dwData["PTSRUESTTAB1"].ToString(); 
          or1.Parameters.Add("PTSPBILD1", OracleType.NVarChar).Value = dwData["PTSPBILD1"].ToString(); 
          or1.Parameters.Add("PTSPAGANG1", OracleType.NVarChar).Value = dwData["PTSPAGANG1"].ToString(); 
          or1.Parameters.Add("PTSPSORT1", OracleType.NVarChar).Value = dwData["PTSPSORT1"].ToString(); 
          or1.Parameters.Add("PTSCONMARK1", OracleType.NVarChar).Value = dwData["PTSCONMARK1"].ToString(); 
          or1.Parameters.Add("PTSSORTFD2", OracleType.NVarChar).Value = dwData["PTSSORTFD2"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE2", OracleType.NVarChar).Value = dwData["PTSPAFOLGE2"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS2", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS2"].ToString(); 
          or1.Parameters.Add("PTSPPKST2", OracleType.NVarChar).Value = dwData["PTSPPKST2"].ToString(); 
          or1.Parameters.Add("PTSMODNR2", OracleType.NVarChar).Value = dwData["PTSMODNR2"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR2", OracleType.NVarChar).Value = dwData["PTSEINSTNR2"].ToString(); 
          or1.Parameters.Add("PTSKAB2", OracleType.NVarChar).Value = dwData["PTSKAB2"].ToString(); 
          or1.Parameters.Add("PTSKLG2", OracleType.NVarChar).Value = dwData["PTSKLG2"].ToString(); 
          or1.Parameters.Add("PTSFELD2", OracleType.NVarChar).Value = dwData["PTSFELD2"].ToString(); 
          or1.Parameters.Add("PTSAB2", OracleType.NVarChar).Value = dwData["PTSAB2"].ToString(); 
          or1.Parameters.Add("PTSAN2", OracleType.NVarChar).Value = dwData["PTSAN2"].ToString(); 
          or1.Parameters.Add("PTSLG2", OracleType.NVarChar).Value = dwData["PTSLG2"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB2", OracleType.NVarChar).Value = dwData["PTSFARBTAB2"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB2", OracleType.NVarChar).Value = dwData["PTSRUESTTAB2"].ToString(); 
          or1.Parameters.Add("PTSPBILD2", OracleType.NVarChar).Value = dwData["PTSPBILD2"].ToString(); 
          or1.Parameters.Add("PTSPAGANG2", OracleType.NVarChar).Value = dwData["PTSPAGANG2"].ToString(); 
          or1.Parameters.Add("PTSPSORT2", OracleType.NVarChar).Value = dwData["PTSPSORT2"].ToString(); 
          or1.Parameters.Add("PTSCONMARK2", OracleType.NVarChar).Value = dwData["PTSCONMARK2"].ToString(); 
          or1.Parameters.Add("PTSSORTFD3", OracleType.NVarChar).Value = dwData["PTSSORTFD3"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE3", OracleType.NVarChar).Value = dwData["PTSPAFOLGE3"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS3", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS3"].ToString(); 
          or1.Parameters.Add("PTSPPKST3", OracleType.NVarChar).Value = dwData["PTSPPKST3"].ToString(); 
          or1.Parameters.Add("PTSMODNR3", OracleType.NVarChar).Value = dwData["PTSMODNR3"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR3", OracleType.NVarChar).Value = dwData["PTSEINSTNR3"].ToString(); 
          or1.Parameters.Add("PTSKAB3", OracleType.NVarChar).Value = dwData["PTSKAB3"].ToString(); 
          or1.Parameters.Add("PTSKLG3", OracleType.NVarChar).Value = dwData["PTSKLG3"].ToString(); 
          or1.Parameters.Add("PTSFELD3", OracleType.NVarChar).Value = dwData["PTSFELD3"].ToString(); 
          or1.Parameters.Add("PTSAB3", OracleType.NVarChar).Value = dwData["PTSAB3"].ToString(); 
          or1.Parameters.Add("PTSAN3", OracleType.NVarChar).Value = dwData["PTSAN3"].ToString(); 
          or1.Parameters.Add("PTSLG3", OracleType.NVarChar).Value = dwData["PTSLG3"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB3", OracleType.NVarChar).Value = dwData["PTSFARBTAB3"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB3", OracleType.NVarChar).Value = dwData["PTSRUESTTAB3"].ToString(); 
          or1.Parameters.Add("PTSPBILD3", OracleType.NVarChar).Value = dwData["PTSPBILD3"].ToString(); 
          or1.Parameters.Add("PTSPAGANG3", OracleType.NVarChar).Value = dwData["PTSPAGANG3"].ToString(); 
          or1.Parameters.Add("PTSPSORT3", OracleType.NVarChar).Value = dwData["PTSPSORT3"].ToString(); 
          or1.Parameters.Add("PTSCONMARK3", OracleType.NVarChar).Value = dwData["PTSCONMARK3"].ToString(); 
          or1.Parameters.Add("PTSSORTFD4", OracleType.NVarChar).Value = dwData["PTSSORTFD4"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE4", OracleType.NVarChar).Value = dwData["PTSPAFOLGE4"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS4", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS4"].ToString(); 
          or1.Parameters.Add("PTSPPKST4", OracleType.NVarChar).Value = dwData["PTSPPKST4"].ToString(); 
          or1.Parameters.Add("PTSMODNR4", OracleType.NVarChar).Value = dwData["PTSMODNR4"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR4", OracleType.NVarChar).Value = dwData["PTSEINSTNR4"].ToString(); 
          or1.Parameters.Add("PTSKAB4", OracleType.NVarChar).Value = dwData["PTSKAB4"].ToString(); 
          or1.Parameters.Add("PTSKLG4", OracleType.NVarChar).Value = dwData["PTSKLG4"].ToString(); 
          or1.Parameters.Add("PTSFELD4", OracleType.NVarChar).Value = dwData["PTSFELD4"].ToString(); 
          or1.Parameters.Add("PTSAB4", OracleType.NVarChar).Value = dwData["PTSAB4"].ToString(); 
          or1.Parameters.Add("PTSAN4", OracleType.NVarChar).Value = dwData["PTSAN4"].ToString(); 
          or1.Parameters.Add("PTSLG4", OracleType.NVarChar).Value = dwData["PTSLG4"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB4", OracleType.NVarChar).Value = dwData["PTSFARBTAB4"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB4", OracleType.NVarChar).Value = dwData["PTSRUESTTAB4"].ToString(); 
          or1.Parameters.Add("PTSPBILD4", OracleType.NVarChar).Value = dwData["PTSPBILD4"].ToString(); 
          or1.Parameters.Add("PTSPAGANG4", OracleType.NVarChar).Value = dwData["PTSPAGANG4"].ToString(); 
          or1.Parameters.Add("PTSPSORT4", OracleType.NVarChar).Value = dwData["PTSPSORT4"].ToString(); 
          or1.Parameters.Add("PTSCONMARK4", OracleType.NVarChar).Value = dwData["PTSCONMARK4"].ToString(); 
          or1.Parameters.Add("PTSSORTFD5", OracleType.NVarChar).Value = dwData["PTSSORTFD5"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE5", OracleType.NVarChar).Value = dwData["PTSPAFOLGE5"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS5", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS5"].ToString(); 
          or1.Parameters.Add("PTSPPKST5", OracleType.NVarChar).Value = dwData["PTSPPKST5"].ToString(); 
          or1.Parameters.Add("PTSMODNR5", OracleType.NVarChar).Value = dwData["PTSMODNR5"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR5", OracleType.NVarChar).Value = dwData["PTSEINSTNR5"].ToString(); 
          or1.Parameters.Add("PTSKAB5", OracleType.NVarChar).Value = dwData["PTSKAB5"].ToString(); 
          or1.Parameters.Add("PTSKLG5", OracleType.NVarChar).Value = dwData["PTSKLG5"].ToString(); 
          or1.Parameters.Add("PTSFELD5", OracleType.NVarChar).Value = dwData["PTSFELD5"].ToString(); 
          or1.Parameters.Add("PTSAB5", OracleType.NVarChar).Value = dwData["PTSAB5"].ToString(); 
          or1.Parameters.Add("PTSAN5", OracleType.NVarChar).Value = dwData["PTSAN5"].ToString(); 
          or1.Parameters.Add("PTSLG5", OracleType.NVarChar).Value = dwData["PTSLG5"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB5", OracleType.NVarChar).Value = dwData["PTSFARBTAB5"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB5", OracleType.NVarChar).Value = dwData["PTSRUESTTAB5"].ToString(); 
          or1.Parameters.Add("PTSPBILD5", OracleType.NVarChar).Value = dwData["PTSPBILD5"].ToString(); 
          or1.Parameters.Add("PTSPAGANG5", OracleType.NVarChar).Value = dwData["PTSPAGANG5"].ToString(); 
          or1.Parameters.Add("PTSPSORT5", OracleType.NVarChar).Value = dwData["PTSPSORT5"].ToString(); 
          or1.Parameters.Add("PTSCONMARK5", OracleType.NVarChar).Value = dwData["PTSCONMARK5"].ToString(); 
          or1.Parameters.Add("PTSSORTFD6", OracleType.NVarChar).Value = dwData["PTSSORTFD6"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE6", OracleType.NVarChar).Value = dwData["PTSPAFOLGE6"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS6", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS6"].ToString(); 
          or1.Parameters.Add("PTSPPKST6", OracleType.NVarChar).Value = dwData["PTSPPKST6"].ToString(); 
          or1.Parameters.Add("PTSMODNR6", OracleType.NVarChar).Value = dwData["PTSMODNR6"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR6", OracleType.NVarChar).Value = dwData["PTSEINSTNR6"].ToString(); 
          or1.Parameters.Add("PTSKAB6", OracleType.NVarChar).Value = dwData["PTSKAB6"].ToString(); 
          or1.Parameters.Add("PTSKLG6", OracleType.NVarChar).Value = dwData["PTSKLG6"].ToString(); 
          or1.Parameters.Add("PTSFELD6", OracleType.NVarChar).Value = dwData["PTSFELD6"].ToString(); 
          or1.Parameters.Add("PTSAB6", OracleType.NVarChar).Value = dwData["PTSAB6"].ToString(); 
          or1.Parameters.Add("PTSAN6", OracleType.NVarChar).Value = dwData["PTSAN6"].ToString(); 
          or1.Parameters.Add("PTSLG6", OracleType.NVarChar).Value = dwData["PTSLG6"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB6", OracleType.NVarChar).Value = dwData["PTSFARBTAB6"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB6", OracleType.NVarChar).Value = dwData["PTSRUESTTAB6"].ToString(); 
          or1.Parameters.Add("PTSPBILD6", OracleType.NVarChar).Value = dwData["PTSPBILD6"].ToString(); 
          or1.Parameters.Add("PTSPAGANG6", OracleType.NVarChar).Value = dwData["PTSPAGANG6"].ToString(); 
          or1.Parameters.Add("PTSPSORT6", OracleType.NVarChar).Value = dwData["PTSPSORT6"].ToString(); 
          or1.Parameters.Add("PTSCONMARK6", OracleType.NVarChar).Value = dwData["PTSCONMARK6"].ToString(); 
          or1.Parameters.Add("PTSSORTFD7", OracleType.NVarChar).Value = dwData["PTSSORTFD7"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE7", OracleType.NVarChar).Value = dwData["PTSPAFOLGE7"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS7", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS7"].ToString(); 
          or1.Parameters.Add("PTSPPKST7", OracleType.NVarChar).Value = dwData["PTSPPKST7"].ToString(); 
          or1.Parameters.Add("PTSMODNR7", OracleType.NVarChar).Value = dwData["PTSMODNR7"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR7", OracleType.NVarChar).Value = dwData["PTSEINSTNR7"].ToString(); 
          or1.Parameters.Add("PTSKAB7", OracleType.NVarChar).Value = dwData["PTSKAB7"].ToString(); 
          or1.Parameters.Add("PTSKLG7", OracleType.NVarChar).Value = dwData["PTSKLG7"].ToString(); 
          or1.Parameters.Add("PTSFELD7", OracleType.NVarChar).Value = dwData["PTSFELD7"].ToString(); 
          or1.Parameters.Add("PTSAB7", OracleType.NVarChar).Value = dwData["PTSAB7"].ToString(); 
          or1.Parameters.Add("PTSAN7", OracleType.NVarChar).Value = dwData["PTSAN7"].ToString(); 
          or1.Parameters.Add("PTSLG7", OracleType.NVarChar).Value = dwData["PTSLG7"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB7", OracleType.NVarChar).Value = dwData["PTSFARBTAB7"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB7", OracleType.NVarChar).Value = dwData["PTSRUESTTAB7"].ToString(); 
          or1.Parameters.Add("PTSPBILD7", OracleType.NVarChar).Value = dwData["PTSPBILD7"].ToString(); 
          or1.Parameters.Add("PTSPAGANG7", OracleType.NVarChar).Value = dwData["PTSPAGANG7"].ToString(); 
          or1.Parameters.Add("PTSPSORT7", OracleType.NVarChar).Value = dwData["PTSPSORT7"].ToString(); 
          or1.Parameters.Add("PTSCONMARK7", OracleType.NVarChar).Value = dwData["PTSCONMARK7"].ToString(); 
          or1.Parameters.Add("PTSSORTFD8", OracleType.NVarChar).Value = dwData["PTSSORTFD8"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE8", OracleType.NVarChar).Value = dwData["PTSPAFOLGE8"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS8", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS8"].ToString(); 
          or1.Parameters.Add("PTSPPKST8", OracleType.NVarChar).Value = dwData["PTSPPKST8"].ToString(); 
          or1.Parameters.Add("PTSMODNR8", OracleType.NVarChar).Value = dwData["PTSMODNR8"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR8", OracleType.NVarChar).Value = dwData["PTSEINSTNR8"].ToString(); 
          or1.Parameters.Add("PTSKAB8", OracleType.NVarChar).Value = dwData["PTSKAB8"].ToString(); 
          or1.Parameters.Add("PTSKLG8", OracleType.NVarChar).Value = dwData["PTSKLG8"].ToString(); 
          or1.Parameters.Add("PTSFELD8", OracleType.NVarChar).Value = dwData["PTSFELD8"].ToString(); 
          or1.Parameters.Add("PTSAB8", OracleType.NVarChar).Value = dwData["PTSAB8"].ToString(); 
          or1.Parameters.Add("PTSAN8", OracleType.NVarChar).Value = dwData["PTSAN8"].ToString(); 
          or1.Parameters.Add("PTSLG8", OracleType.NVarChar).Value = dwData["PTSLG8"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB8", OracleType.NVarChar).Value = dwData["PTSFARBTAB8"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB8", OracleType.NVarChar).Value = dwData["PTSRUESTTAB8"].ToString(); 
          or1.Parameters.Add("PTSPBILD8", OracleType.NVarChar).Value = dwData["PTSPBILD8"].ToString(); 
          or1.Parameters.Add("PTSPAGANG8", OracleType.NVarChar).Value = dwData["PTSPAGANG8"].ToString(); 
          or1.Parameters.Add("PTSPSORT8", OracleType.NVarChar).Value = dwData["PTSPSORT8"].ToString(); 
          or1.Parameters.Add("PTSCONMARK8", OracleType.NVarChar).Value = dwData["PTSCONMARK8"].ToString(); 
          or1.Parameters.Add("PTSSORTFD9", OracleType.NVarChar).Value = dwData["PTSSORTFD9"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE9", OracleType.NVarChar).Value = dwData["PTSPAFOLGE9"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS9", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS9"].ToString(); 
          or1.Parameters.Add("PTSPPKST9", OracleType.NVarChar).Value = dwData["PTSPPKST9"].ToString(); 
          or1.Parameters.Add("PTSMODNR9", OracleType.NVarChar).Value = dwData["PTSMODNR9"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR9", OracleType.NVarChar).Value = dwData["PTSEINSTNR9"].ToString(); 
          or1.Parameters.Add("PTSKAB9", OracleType.NVarChar).Value = dwData["PTSKAB9"].ToString(); 
          or1.Parameters.Add("PTSKLG9", OracleType.NVarChar).Value = dwData["PTSKLG9"].ToString(); 
          or1.Parameters.Add("PTSFELD9", OracleType.NVarChar).Value = dwData["PTSFELD9"].ToString(); 
          or1.Parameters.Add("PTSAB9", OracleType.NVarChar).Value = dwData["PTSAB9"].ToString(); 
          or1.Parameters.Add("PTSAN9", OracleType.NVarChar).Value = dwData["PTSAN9"].ToString(); 
          or1.Parameters.Add("PTSLG9", OracleType.NVarChar).Value = dwData["PTSLG9"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB9", OracleType.NVarChar).Value = dwData["PTSFARBTAB9"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB9", OracleType.NVarChar).Value = dwData["PTSRUESTTAB9"].ToString(); 
          or1.Parameters.Add("PTSPBILD9", OracleType.NVarChar).Value = dwData["PTSPBILD9"].ToString(); 
          or1.Parameters.Add("PTSPAGANG9", OracleType.NVarChar).Value = dwData["PTSPAGANG9"].ToString(); 
          or1.Parameters.Add("PTSPSORT9", OracleType.NVarChar).Value = dwData["PTSPSORT9"].ToString(); 
          or1.Parameters.Add("PTSCONMARK9", OracleType.NVarChar).Value = dwData["PTSCONMARK9"].ToString(); 
          or1.Parameters.Add("PTSSORTFD10", OracleType.NVarChar).Value = dwData["PTSSORTFD10"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE10", OracleType.NVarChar).Value = dwData["PTSPAFOLGE10"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS10", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS10"].ToString(); 
          or1.Parameters.Add("PTSPPKST10", OracleType.NVarChar).Value = dwData["PTSPPKST10"].ToString(); 
          or1.Parameters.Add("PTSMODNR10", OracleType.NVarChar).Value = dwData["PTSMODNR10"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR10", OracleType.NVarChar).Value = dwData["PTSEINSTNR10"].ToString(); 
          or1.Parameters.Add("PTSKAB10", OracleType.NVarChar).Value = dwData["PTSKAB10"].ToString(); 
          or1.Parameters.Add("PTSKLG10", OracleType.NVarChar).Value = dwData["PTSKLG10"].ToString(); 
          or1.Parameters.Add("PTSFELD10", OracleType.NVarChar).Value = dwData["PTSFELD10"].ToString(); 
          or1.Parameters.Add("PTSAB10", OracleType.NVarChar).Value = dwData["PTSAB10"].ToString(); 
          or1.Parameters.Add("PTSAN10", OracleType.NVarChar).Value = dwData["PTSAN10"].ToString(); 
          or1.Parameters.Add("PTSLG10", OracleType.NVarChar).Value = dwData["PTSLG10"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB10", OracleType.NVarChar).Value = dwData["PTSFARBTAB10"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB10", OracleType.NVarChar).Value = dwData["PTSRUESTTAB10"].ToString(); 
          or1.Parameters.Add("PTSPBILD10", OracleType.NVarChar).Value = dwData["PTSPBILD10"].ToString(); 
          or1.Parameters.Add("PTSPAGANG10", OracleType.NVarChar).Value = dwData["PTSPAGANG10"].ToString(); 
          or1.Parameters.Add("PTSPSORT10", OracleType.NVarChar).Value = dwData["PTSPSORT10"].ToString(); 
          or1.Parameters.Add("PTSCONMARK10", OracleType.NVarChar).Value = dwData["PTSCONMARK10"].ToString(); 
          or1.Parameters.Add("PTSSORTFD11", OracleType.NVarChar).Value = dwData["PTSSORTFD11"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE11", OracleType.NVarChar).Value = dwData["PTSPAFOLGE11"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS11", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS11"].ToString(); 
          or1.Parameters.Add("PTSPPKST11", OracleType.NVarChar).Value = dwData["PTSPPKST11"].ToString(); 
          or1.Parameters.Add("PTSMODNR11", OracleType.NVarChar).Value = dwData["PTSMODNR11"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR11", OracleType.NVarChar).Value = dwData["PTSEINSTNR11"].ToString(); 
          or1.Parameters.Add("PTSKAB11", OracleType.NVarChar).Value = dwData["PTSKAB11"].ToString(); 
          or1.Parameters.Add("PTSKLG11", OracleType.NVarChar).Value = dwData["PTSKLG11"].ToString(); 
          or1.Parameters.Add("PTSFELD11", OracleType.NVarChar).Value = dwData["PTSFELD11"].ToString(); 
          or1.Parameters.Add("PTSAB11", OracleType.NVarChar).Value = dwData["PTSAB11"].ToString(); 
          or1.Parameters.Add("PTSAN11", OracleType.NVarChar).Value = dwData["PTSAN11"].ToString(); 
          or1.Parameters.Add("PTSLG11", OracleType.NVarChar).Value = dwData["PTSLG11"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB11", OracleType.NVarChar).Value = dwData["PTSFARBTAB11"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB11", OracleType.NVarChar).Value = dwData["PTSRUESTTAB11"].ToString(); 
          or1.Parameters.Add("PTSPBILD11", OracleType.NVarChar).Value = dwData["PTSPBILD11"].ToString(); 
          or1.Parameters.Add("PTSPAGANG11", OracleType.NVarChar).Value = dwData["PTSPAGANG11"].ToString(); 
          or1.Parameters.Add("PTSPSORT11", OracleType.NVarChar).Value = dwData["PTSPSORT11"].ToString(); 
          or1.Parameters.Add("PTSCONMARK11", OracleType.NVarChar).Value = dwData["PTSCONMARK11"].ToString(); 
          or1.Parameters.Add("PTSSORTFD12", OracleType.NVarChar).Value = dwData["PTSSORTFD12"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE12", OracleType.NVarChar).Value = dwData["PTSPAFOLGE12"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS12", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS12"].ToString(); 
          or1.Parameters.Add("PTSPPKST12", OracleType.NVarChar).Value = dwData["PTSPPKST12"].ToString(); 
          or1.Parameters.Add("PTSMODNR12", OracleType.NVarChar).Value = dwData["PTSMODNR12"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR12", OracleType.NVarChar).Value = dwData["PTSEINSTNR12"].ToString(); 
          or1.Parameters.Add("PTSKAB12", OracleType.NVarChar).Value = dwData["PTSKAB12"].ToString(); 
          or1.Parameters.Add("PTSKLG12", OracleType.NVarChar).Value = dwData["PTSKLG12"].ToString(); 
          or1.Parameters.Add("PTSFELD12", OracleType.NVarChar).Value = dwData["PTSFELD12"].ToString(); 
          or1.Parameters.Add("PTSAB12", OracleType.NVarChar).Value = dwData["PTSAB12"].ToString(); 
          or1.Parameters.Add("PTSAN12", OracleType.NVarChar).Value = dwData["PTSAN12"].ToString(); 
          or1.Parameters.Add("PTSLG12", OracleType.NVarChar).Value = dwData["PTSLG12"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB12", OracleType.NVarChar).Value = dwData["PTSFARBTAB12"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB12", OracleType.NVarChar).Value = dwData["PTSRUESTTAB12"].ToString(); 
          or1.Parameters.Add("PTSPBILD12", OracleType.NVarChar).Value = dwData["PTSPBILD12"].ToString(); 
          or1.Parameters.Add("PTSPAGANG12", OracleType.NVarChar).Value = dwData["PTSPAGANG12"].ToString(); 
          or1.Parameters.Add("PTSPSORT12", OracleType.NVarChar).Value = dwData["PTSPSORT12"].ToString(); 
          or1.Parameters.Add("PTSCONMARK12", OracleType.NVarChar).Value = dwData["PTSCONMARK12"].ToString(); 
          or1.Parameters.Add("PTSSORTFD13", OracleType.NVarChar).Value = dwData["PTSSORTFD13"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE13", OracleType.NVarChar).Value = dwData["PTSPAFOLGE13"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS13", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS13"].ToString(); 
          or1.Parameters.Add("PTSPPKST13", OracleType.NVarChar).Value = dwData["PTSPPKST13"].ToString(); 
          or1.Parameters.Add("PTSMODNR13", OracleType.NVarChar).Value = dwData["PTSMODNR13"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR13", OracleType.NVarChar).Value = dwData["PTSEINSTNR13"].ToString(); 
          or1.Parameters.Add("PTSKAB13", OracleType.NVarChar).Value = dwData["PTSKAB13"].ToString(); 
          or1.Parameters.Add("PTSKLG13", OracleType.NVarChar).Value = dwData["PTSKLG13"].ToString(); 
          or1.Parameters.Add("PTSFELD13", OracleType.NVarChar).Value = dwData["PTSFELD13"].ToString(); 
          or1.Parameters.Add("PTSAB13", OracleType.NVarChar).Value = dwData["PTSAB13"].ToString(); 
          or1.Parameters.Add("PTSAN13", OracleType.NVarChar).Value = dwData["PTSAN13"].ToString(); 
          or1.Parameters.Add("PTSLG13", OracleType.NVarChar).Value = dwData["PTSLG13"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB13", OracleType.NVarChar).Value = dwData["PTSFARBTAB13"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB13", OracleType.NVarChar).Value = dwData["PTSRUESTTAB13"].ToString(); 
          or1.Parameters.Add("PTSPBILD13", OracleType.NVarChar).Value = dwData["PTSPBILD13"].ToString(); 
          or1.Parameters.Add("PTSPAGANG13", OracleType.NVarChar).Value = dwData["PTSPAGANG13"].ToString(); 
          or1.Parameters.Add("PTSPSORT13", OracleType.NVarChar).Value = dwData["PTSPSORT13"].ToString(); 
          or1.Parameters.Add("PTSCONMARK13", OracleType.NVarChar).Value = dwData["PTSCONMARK13"].ToString(); 
          or1.Parameters.Add("PTSSORTFD14", OracleType.NVarChar).Value = dwData["PTSSORTFD14"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE14", OracleType.NVarChar).Value = dwData["PTSPAFOLGE14"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS14", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS14"].ToString(); 
          or1.Parameters.Add("PTSPPKST14", OracleType.NVarChar).Value = dwData["PTSPPKST14"].ToString(); 
          or1.Parameters.Add("PTSMODNR14", OracleType.NVarChar).Value = dwData["PTSMODNR14"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR14", OracleType.NVarChar).Value = dwData["PTSEINSTNR14"].ToString(); 
          or1.Parameters.Add("PTSKAB14", OracleType.NVarChar).Value = dwData["PTSKAB14"].ToString(); 
          or1.Parameters.Add("PTSKLG14", OracleType.NVarChar).Value = dwData["PTSKLG14"].ToString(); 
          or1.Parameters.Add("PTSFELD14", OracleType.NVarChar).Value = dwData["PTSFELD14"].ToString(); 
          or1.Parameters.Add("PTSAB14", OracleType.NVarChar).Value = dwData["PTSAB14"].ToString(); 
          or1.Parameters.Add("PTSAN14", OracleType.NVarChar).Value = dwData["PTSAN14"].ToString(); 
          or1.Parameters.Add("PTSLG14", OracleType.NVarChar).Value = dwData["PTSLG14"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB14", OracleType.NVarChar).Value = dwData["PTSFARBTAB14"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB14", OracleType.NVarChar).Value = dwData["PTSRUESTTAB14"].ToString(); 
          or1.Parameters.Add("PTSPBILD14", OracleType.NVarChar).Value = dwData["PTSPBILD14"].ToString(); 
          or1.Parameters.Add("PTSPAGANG14", OracleType.NVarChar).Value = dwData["PTSPAGANG14"].ToString(); 
          or1.Parameters.Add("PTSPSORT14", OracleType.NVarChar).Value = dwData["PTSPSORT14"].ToString(); 
          or1.Parameters.Add("PTSCONMARK14", OracleType.NVarChar).Value = dwData["PTSCONMARK14"].ToString(); 
          or1.Parameters.Add("PTSSORTFD15", OracleType.NVarChar).Value = dwData["PTSSORTFD15"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE15", OracleType.NVarChar).Value = dwData["PTSPAFOLGE15"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS15", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS15"].ToString(); 
          or1.Parameters.Add("PTSPPKST15", OracleType.NVarChar).Value = dwData["PTSPPKST15"].ToString(); 
          or1.Parameters.Add("PTSMODNR15", OracleType.NVarChar).Value = dwData["PTSMODNR15"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR15", OracleType.NVarChar).Value = dwData["PTSEINSTNR15"].ToString(); 
          or1.Parameters.Add("PTSKAB15", OracleType.NVarChar).Value = dwData["PTSKAB15"].ToString(); 
          or1.Parameters.Add("PTSKLG15", OracleType.NVarChar).Value = dwData["PTSKLG15"].ToString(); 
          or1.Parameters.Add("PTSFELD15", OracleType.NVarChar).Value = dwData["PTSFELD15"].ToString(); 
          or1.Parameters.Add("PTSAB15", OracleType.NVarChar).Value = dwData["PTSAB15"].ToString(); 
          or1.Parameters.Add("PTSAN15", OracleType.NVarChar).Value = dwData["PTSAN15"].ToString(); 
          or1.Parameters.Add("PTSLG15", OracleType.NVarChar).Value = dwData["PTSLG15"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB15", OracleType.NVarChar).Value = dwData["PTSFARBTAB15"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB15", OracleType.NVarChar).Value = dwData["PTSRUESTTAB15"].ToString(); 
          or1.Parameters.Add("PTSPBILD15", OracleType.NVarChar).Value = dwData["PTSPBILD15"].ToString(); 
          or1.Parameters.Add("PTSPAGANG15", OracleType.NVarChar).Value = dwData["PTSPAGANG15"].ToString(); 
          or1.Parameters.Add("PTSPSORT15", OracleType.NVarChar).Value = dwData["PTSPSORT15"].ToString(); 
          or1.Parameters.Add("PTSCONMARK15", OracleType.NVarChar).Value = dwData["PTSCONMARK15"].ToString(); 
          or1.Parameters.Add("PTSSORTFD16", OracleType.NVarChar).Value = dwData["PTSSORTFD16"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE16", OracleType.NVarChar).Value = dwData["PTSPAFOLGE16"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS16", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS16"].ToString(); 
          or1.Parameters.Add("PTSPPKST16", OracleType.NVarChar).Value = dwData["PTSPPKST16"].ToString(); 
          or1.Parameters.Add("PTSMODNR16", OracleType.NVarChar).Value = dwData["PTSMODNR16"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR16", OracleType.NVarChar).Value = dwData["PTSEINSTNR16"].ToString(); 
          or1.Parameters.Add("PTSKAB16", OracleType.NVarChar).Value = dwData["PTSKAB16"].ToString(); 
          or1.Parameters.Add("PTSKLG16", OracleType.NVarChar).Value = dwData["PTSKLG16"].ToString(); 
          or1.Parameters.Add("PTSFELD16", OracleType.NVarChar).Value = dwData["PTSFELD16"].ToString(); 
          or1.Parameters.Add("PTSAB16", OracleType.NVarChar).Value = dwData["PTSAB16"].ToString(); 
          or1.Parameters.Add("PTSAN16", OracleType.NVarChar).Value = dwData["PTSAN16"].ToString(); 
          or1.Parameters.Add("PTSLG16", OracleType.NVarChar).Value = dwData["PTSLG16"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB16", OracleType.NVarChar).Value = dwData["PTSFARBTAB16"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB16", OracleType.NVarChar).Value = dwData["PTSRUESTTAB16"].ToString(); 
          or1.Parameters.Add("PTSPBILD16", OracleType.NVarChar).Value = dwData["PTSPBILD16"].ToString(); 
          or1.Parameters.Add("PTSPAGANG16", OracleType.NVarChar).Value = dwData["PTSPAGANG16"].ToString(); 
          or1.Parameters.Add("PTSPSORT16", OracleType.NVarChar).Value = dwData["PTSPSORT16"].ToString(); 
          or1.Parameters.Add("PTSCONMARK16", OracleType.NVarChar).Value = dwData["PTSCONMARK16"].ToString(); 
          or1.Parameters.Add("PTSSORTFD17", OracleType.NVarChar).Value = dwData["PTSSORTFD17"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE17", OracleType.NVarChar).Value = dwData["PTSPAFOLGE17"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS17", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS17"].ToString(); 
          or1.Parameters.Add("PTSPPKST17", OracleType.NVarChar).Value = dwData["PTSPPKST17"].ToString(); 
          or1.Parameters.Add("PTSMODNR17", OracleType.NVarChar).Value = dwData["PTSMODNR17"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR17", OracleType.NVarChar).Value = dwData["PTSEINSTNR17"].ToString(); 
          or1.Parameters.Add("PTSKAB17", OracleType.NVarChar).Value = dwData["PTSKAB17"].ToString(); 
          or1.Parameters.Add("PTSKLG17", OracleType.NVarChar).Value = dwData["PTSKLG17"].ToString(); 
          or1.Parameters.Add("PTSFELD17", OracleType.NVarChar).Value = dwData["PTSFELD17"].ToString(); 
          or1.Parameters.Add("PTSAB17", OracleType.NVarChar).Value = dwData["PTSAB17"].ToString(); 
          or1.Parameters.Add("PTSAN17", OracleType.NVarChar).Value = dwData["PTSAN17"].ToString(); 
          or1.Parameters.Add("PTSLG17", OracleType.NVarChar).Value = dwData["PTSLG17"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB17", OracleType.NVarChar).Value = dwData["PTSFARBTAB17"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB17", OracleType.NVarChar).Value = dwData["PTSRUESTTAB17"].ToString(); 
          or1.Parameters.Add("PTSPBILD17", OracleType.NVarChar).Value = dwData["PTSPBILD17"].ToString(); 
          or1.Parameters.Add("PTSPAGANG17", OracleType.NVarChar).Value = dwData["PTSPAGANG17"].ToString(); 
          or1.Parameters.Add("PTSPSORT17", OracleType.NVarChar).Value = dwData["PTSPSORT17"].ToString(); 
          or1.Parameters.Add("PTSCONMARK17", OracleType.NVarChar).Value = dwData["PTSCONMARK17"].ToString(); 
          or1.Parameters.Add("PTSSORTFD18", OracleType.NVarChar).Value = dwData["PTSSORTFD18"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE18", OracleType.NVarChar).Value = dwData["PTSPAFOLGE18"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS18", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS18"].ToString(); 
          or1.Parameters.Add("PTSPPKST18", OracleType.NVarChar).Value = dwData["PTSPPKST18"].ToString(); 
          or1.Parameters.Add("PTSMODNR18", OracleType.NVarChar).Value = dwData["PTSMODNR18"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR18", OracleType.NVarChar).Value = dwData["PTSEINSTNR18"].ToString(); 
          or1.Parameters.Add("PTSKAB18", OracleType.NVarChar).Value = dwData["PTSKAB18"].ToString(); 
          or1.Parameters.Add("PTSKLG18", OracleType.NVarChar).Value = dwData["PTSKLG18"].ToString(); 
          or1.Parameters.Add("PTSFELD18", OracleType.NVarChar).Value = dwData["PTSFELD18"].ToString(); 
          or1.Parameters.Add("PTSAB18", OracleType.NVarChar).Value = dwData["PTSAB18"].ToString(); 
          or1.Parameters.Add("PTSAN18", OracleType.NVarChar).Value = dwData["PTSAN18"].ToString(); 
          or1.Parameters.Add("PTSLG18", OracleType.NVarChar).Value = dwData["PTSLG18"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB18", OracleType.NVarChar).Value = dwData["PTSFARBTAB18"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB18", OracleType.NVarChar).Value = dwData["PTSRUESTTAB18"].ToString(); 
          or1.Parameters.Add("PTSPBILD18", OracleType.NVarChar).Value = dwData["PTSPBILD18"].ToString(); 
          or1.Parameters.Add("PTSPAGANG18", OracleType.NVarChar).Value = dwData["PTSPAGANG18"].ToString(); 
          or1.Parameters.Add("PTSPSORT18", OracleType.NVarChar).Value = dwData["PTSPSORT18"].ToString(); 
          or1.Parameters.Add("PTSCONMARK18", OracleType.NVarChar).Value = dwData["PTSCONMARK18"].ToString(); 
          or1.Parameters.Add("PTSSORTFD19", OracleType.NVarChar).Value = dwData["PTSSORTFD19"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE19", OracleType.NVarChar).Value = dwData["PTSPAFOLGE19"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS19", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS19"].ToString(); 
          or1.Parameters.Add("PTSPPKST19", OracleType.NVarChar).Value = dwData["PTSPPKST19"].ToString(); 
          or1.Parameters.Add("PTSMODNR19", OracleType.NVarChar).Value = dwData["PTSMODNR19"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR19", OracleType.NVarChar).Value = dwData["PTSEINSTNR19"].ToString(); 
          or1.Parameters.Add("PTSKAB19", OracleType.NVarChar).Value = dwData["PTSKAB19"].ToString(); 
          or1.Parameters.Add("PTSKLG19", OracleType.NVarChar).Value = dwData["PTSKLG19"].ToString(); 
          or1.Parameters.Add("PTSFELD19", OracleType.NVarChar).Value = dwData["PTSFELD19"].ToString(); 
          or1.Parameters.Add("PTSAB19", OracleType.NVarChar).Value = dwData["PTSAB19"].ToString(); 
          or1.Parameters.Add("PTSAN19", OracleType.NVarChar).Value = dwData["PTSAN19"].ToString(); 
          or1.Parameters.Add("PTSLG19", OracleType.NVarChar).Value = dwData["PTSLG19"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB19", OracleType.NVarChar).Value = dwData["PTSFARBTAB19"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB19", OracleType.NVarChar).Value = dwData["PTSRUESTTAB19"].ToString(); 
          or1.Parameters.Add("PTSPBILD19", OracleType.NVarChar).Value = dwData["PTSPBILD19"].ToString(); 
          or1.Parameters.Add("PTSPAGANG19", OracleType.NVarChar).Value = dwData["PTSPAGANG19"].ToString(); 
          or1.Parameters.Add("PTSPSORT19", OracleType.NVarChar).Value = dwData["PTSPSORT19"].ToString(); 
          or1.Parameters.Add("PTSCONMARK19", OracleType.NVarChar).Value = dwData["PTSCONMARK19"].ToString(); 
          or1.Parameters.Add("PTSSORTFD20", OracleType.NVarChar).Value = dwData["PTSSORTFD20"].ToString(); 
          or1.Parameters.Add("PTSPAFOLGE20", OracleType.NVarChar).Value = dwData["PTSPAFOLGE20"].ToString(); 
          or1.Parameters.Add("PTSPPKSTKRS20", OracleType.NVarChar).Value = dwData["PTSPPKSTKRS20"].ToString(); 
          or1.Parameters.Add("PTSPPKST20", OracleType.NVarChar).Value = dwData["PTSPPKST20"].ToString(); 
          or1.Parameters.Add("PTSMODNR20", OracleType.NVarChar).Value = dwData["PTSMODNR20"].ToString(); 
          or1.Parameters.Add("PTSEINSTNR20", OracleType.NVarChar).Value = dwData["PTSEINSTNR20"].ToString(); 
          or1.Parameters.Add("PTSKAB20", OracleType.NVarChar).Value = dwData["PTSKAB20"].ToString(); 
          or1.Parameters.Add("PTSKLG20", OracleType.NVarChar).Value = dwData["PTSKLG20"].ToString(); 
          or1.Parameters.Add("PTSFELD20", OracleType.NVarChar).Value = dwData["PTSFELD20"].ToString(); 
          or1.Parameters.Add("PTSAB20", OracleType.NVarChar).Value = dwData["PTSAB20"].ToString(); 
          or1.Parameters.Add("PTSAN20", OracleType.NVarChar).Value = dwData["PTSAN20"].ToString(); 
          or1.Parameters.Add("PTSLG20", OracleType.NVarChar).Value = dwData["PTSLG20"].ToString(); 
          or1.Parameters.Add("PTSFARBTAB20", OracleType.NVarChar).Value = dwData["PTSFARBTAB20"].ToString(); 
          or1.Parameters.Add("PTSRUESTTAB20", OracleType.NVarChar).Value = dwData["PTSRUESTTAB20"].ToString(); 
          or1.Parameters.Add("PTSPBILD20", OracleType.NVarChar).Value = dwData["PTSPBILD20"].ToString(); 
          or1.Parameters.Add("PTSPAGANG20", OracleType.NVarChar).Value = dwData["PTSPAGANG20"].ToString(); 
          or1.Parameters.Add("PTSPSORT20", OracleType.NVarChar).Value = dwData["PTSPSORT20"].ToString(); 
          or1.Parameters.Add("PTSCONMARK20", OracleType.NVarChar).Value = dwData["PTSCONMARK20"].ToString(); 
          or1.Parameters.Add("PTSAPTNRKRS", OracleType.NVarChar).Value = dwData["PTSAPTNRKRS"].ToString(); 
          or1.Parameters.Add("PTSAME1", OracleType.NVarChar).Value = dwData["PTSAME1"].ToString(); 
          or1.Parameters.Add("PTSAME2", OracleType.NVarChar).Value = dwData["PTSAME2"].ToString(); 
          or1.Parameters.Add("PTSAGRP", OracleType.NVarChar).Value = dwData["PTSAGRP"].ToString(); 
          or1.Parameters.Add("PTSBPTNRKRS", OracleType.NVarChar).Value = dwData["PTSBPTNRKRS"].ToString(); 
          or1.Parameters.Add("PTSART", OracleType.NVarChar).Value = dwData["PTSART"].ToString(); 
          or1.Parameters.Add("PTSBME1", OracleType.NVarChar).Value = dwData["PTSBME1"].ToString(); 
          or1.Parameters.Add("PTSBME2", OracleType.NVarChar).Value = dwData["PTSBME2"].ToString(); 
          or1.Parameters.Add("PTSBGRP", OracleType.NVarChar).Value = dwData["PTSBGRP"].ToString(); 
          or1.Parameters.Add("PTSKUNDE", OracleType.NVarChar).Value = dwData["PTSKUNDE"].ToString(); 
          or1.Parameters.Add("PTSPFLKZ", OracleType.NVarChar).Value = dwData["PTSPFLKZ"].ToString(); 
          or1.Parameters.Add("PTSTERM", OracleType.NVarChar).Value = dwData["PTSTERM"].ToString(); 
          or1.Parameters.Add("PTSMTYPKZ", OracleType.NVarChar).Value = dwData["PTSMTYPKZ"].ToString(); 
          or1.Parameters.Add("PTSWEEKPL", OracleType.NVarChar).Value = dwData["PTSWEEKPL"].ToString(); 
          or1.Parameters.Add("PTSWEEK", OracleType.NVarChar).Value = dwData["PTSWEEK"].ToString(); 
          or1.Parameters.Add("PTSWEEKST", OracleType.NVarChar).Value = dwData["PTSWEEKST"].ToString(); 
          or1.Parameters.Add("PTSSETUPTM", OracleType.NVarChar).Value = dwData["PTSSETUPTM"].ToString(); 
          or1.Parameters.Add("PTSSETUPTM1", OracleType.NVarChar).Value = dwData["PTSSETUPTM1"].ToString(); 
          or1.Parameters.Add("PTSSETUPTM2", OracleType.NVarChar).Value = dwData["PTSSETUPTM2"].ToString(); 
          or1.Parameters.Add("PTSSCROLL", OracleType.NVarChar).Value = dwData["PTSSCROLL"].ToString(); 
          or1.Parameters.Add("PTSCONDAT", OracleType.NVarChar).Value = dwData["PTSCONDAT"].ToString(); 
          or1.Parameters.Add("PTSFILLER", OracleType.NVarChar).Value = dwData["PTSFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
